object dm_principal: Tdm_principal
  OldCreateOrder = False
  Height = 420
  Width = 664
  object sql_con: TSQLConnection
    ConnectionName = 'FBConnection'
    DriverName = 'Firebird'
    LoginPrompt = False
    Params.Strings = (
      'DriverUnit=Data.DBXFirebird'
      
        'DriverPackageLoader=TDBXDynalinkDriverLoader,DbxCommonDriver190.' +
        'bpl'
      
        'DriverAssemblyLoader=Borland.Data.TDBXDynalinkDriverLoader,Borla' +
        'nd.Data.DbxCommonDriver,Version=19.0.0.0,Culture=neutral,PublicK' +
        'eyToken=91d62ebb5b0d1b1b'
      
        'MetaDataPackageLoader=TDBXFirebirdMetaDataCommandFactory,DbxFire' +
        'birdDriver190.bpl'
      
        'MetaDataAssemblyLoader=Borland.Data.TDBXFirebirdMetaDataCommandF' +
        'actory,Borland.Data.DbxFirebirdDriver,Version=19.0.0.0,Culture=n' +
        'eutral,PublicKeyToken=91d62ebb5b0d1b1b'
      'GetDriverFunc=getSQLDriverINTERBASE'
      'LibraryName=dbxfb.dll'
      'LibraryNameOsx=libsqlfb.dylib'
      'VendorLib=fbclient.dll'
      'VendorLibWin64=fbclient.dll'
      'VendorLibOsx=/Library/Frameworks/Firebird.framework/Firebird'
      'Role=RoleName'
      'MaxBlobSize=-1'
      'TrimChar=False'
      'DriverName=Firebird'
      'Database=G:\Projetos\Smart School\Banco\DB.FDB'
      'RoleName=RoleName'
      'User_Name=sysdba'
      'Password=masterkey'
      'ServerCharSet='
      'SQLDialect=3'
      'ErrorResourceFile='
      'LocaleCode=0000'
      'BlobSize=-1'
      'CommitRetain=False'
      'WaitOnLocks=True'
      'IsolationLevel=ReadCommitted'
      'Trim Char=False')
    BeforeConnect = sql_conBeforeConnect
    Left = 40
    Top = 24
  end
  object qry_usuario: TSQLDataSet
    CommandText = 'select *  from usuario'
    MaxBlobSize = -1
    Params = <>
    SQLConnection = sql_con
    Left = 40
    Top = 80
    object qry_usuarioUSER_ID: TIntegerField
      FieldName = 'USER_ID'
      Required = True
    end
    object qry_usuarioUSER_NOME: TStringField
      FieldName = 'USER_NOME'
      Size = 50
    end
    object qry_usuarioUSER_LOGIN: TStringField
      FieldName = 'USER_LOGIN'
      Size = 19
    end
    object qry_usuarioUSER_SENHA: TStringField
      FieldName = 'USER_SENHA'
      Size = 10
    end
    object qry_usuarioUSER_TIPO: TIntegerField
      FieldName = 'USER_TIPO'
      Required = True
    end
  end
  object dsp_usuario: TDataSetProvider
    DataSet = qry_usuario
    Left = 40
    Top = 128
  end
  object cds_usuario: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'dsp_usuario'
    Left = 40
    Top = 176
    object cds_usuarioUSER_ID: TIntegerField
      FieldName = 'USER_ID'
      Required = True
    end
    object cds_usuarioUSER_NOME: TStringField
      FieldName = 'USER_NOME'
      Size = 50
    end
    object cds_usuarioUSER_LOGIN: TStringField
      FieldName = 'USER_LOGIN'
      Size = 19
    end
    object cds_usuarioUSER_SENHA: TStringField
      FieldName = 'USER_SENHA'
      Size = 10
    end
    object cds_usuarioUSER_TIPO: TIntegerField
      FieldName = 'USER_TIPO'
      Required = True
    end
  end
  object ds_usuario: TDataSource
    DataSet = cds_usuario
    Left = 32
    Top = 232
  end
  object sq_generators: TSQLQuery
    MaxBlobSize = -1
    Params = <>
    SQLConnection = sql_con
    Left = 176
    Top = 32
  end
  object qry_aluno: TSQLDataSet
    CommandText = 
      'select ALU_ALERGIA, ALU_BAIRRO, ALU_BAIRRO1, ALU_BAIRRO2, ALU_CI' +
      'DADE, ALU_CIDADE1, ALU_CIDADE2, ALU_DATA_DESLIGAMENTO, ALU_DATA_' +
      'MATRICULA, ALU_DATA_NASC, ALU_DEFICIENCAS, ALU_DOENCA, ALU_DOENC' +
      'A_CONTAGIOSA, ALU_ENDERECO, ALU_ENDERECO1, ALU_ENDERECO2, ALU_FK' +
      'TUR_ID, ALU_FOTO, ALU_GRAU_PARENTESCO1, ALU_GRAU_PARENTESCO2, AL' +
      'U_ID, ALU_NACIONALIDADE, ALU_NATURALIDADE, ALU_NOME, ALU_NOME_MA' +
      'E, ALU_NOME_PAI, ALU_NOME_PLANO_SAUDE, ALU_NOME_RESPONSAVEL1, AL' +
      'U_NOME_RESPONSAVEL2, ALU_NUMERO, ALU_NUMERO_CARTERINHA, ALU_NUME' +
      'RO_MATRICULA, ALU_NUMERO1, ALU_NUMERO2, ALU_OBSERVACOES, ALU_ORG' +
      'AO_EMISSOR, ALU_POSSUI_ALERGIA, ALU_RG, ALU_SEXO, ALU_SITUACAO, ' +
      'ALU_TELEFONE, ALU_TELEFONE_SAUDE, ALU_TELEFONE1, ALU_TELEFONE2, ' +
      'ALU_TIPO_SANGUINEO, ALU_VACINAS'#13#10'from aluno'
    MaxBlobSize = 1
    Params = <>
    SQLConnection = sql_con
    Left = 112
    Top = 88
    object qry_alunoALU_ALERGIA: TMemoField
      FieldName = 'ALU_ALERGIA'
      BlobType = ftMemo
      Size = 1
    end
    object qry_alunoALU_BAIRRO: TStringField
      FieldName = 'ALU_BAIRRO'
      Size = 40
    end
    object qry_alunoALU_BAIRRO1: TStringField
      FieldName = 'ALU_BAIRRO1'
      Size = 40
    end
    object qry_alunoALU_BAIRRO2: TStringField
      FieldName = 'ALU_BAIRRO2'
      Size = 40
    end
    object qry_alunoALU_CIDADE: TStringField
      FieldName = 'ALU_CIDADE'
      Size = 50
    end
    object qry_alunoALU_CIDADE1: TStringField
      FieldName = 'ALU_CIDADE1'
      Size = 50
    end
    object qry_alunoALU_CIDADE2: TStringField
      FieldName = 'ALU_CIDADE2'
      Size = 50
    end
    object qry_alunoALU_DATA_DESLIGAMENTO: TDateField
      FieldName = 'ALU_DATA_DESLIGAMENTO'
    end
    object qry_alunoALU_DATA_MATRICULA: TDateField
      FieldName = 'ALU_DATA_MATRICULA'
    end
    object qry_alunoALU_DATA_NASC: TDateField
      FieldName = 'ALU_DATA_NASC'
    end
    object qry_alunoALU_DEFICIENCAS: TMemoField
      FieldName = 'ALU_DEFICIENCAS'
      BlobType = ftMemo
      Size = 1
    end
    object qry_alunoALU_DOENCA: TMemoField
      FieldName = 'ALU_DOENCA'
      BlobType = ftMemo
      Size = 1
    end
    object qry_alunoALU_DOENCA_CONTAGIOSA: TMemoField
      FieldName = 'ALU_DOENCA_CONTAGIOSA'
      BlobType = ftMemo
      Size = 1
    end
    object qry_alunoALU_ENDERECO: TStringField
      FieldName = 'ALU_ENDERECO'
      Size = 30
    end
    object qry_alunoALU_ENDERECO1: TStringField
      FieldName = 'ALU_ENDERECO1'
      Size = 30
    end
    object qry_alunoALU_ENDERECO2: TStringField
      FieldName = 'ALU_ENDERECO2'
      Size = 30
    end
    object qry_alunoALU_FKTUR_ID: TIntegerField
      FieldName = 'ALU_FKTUR_ID'
    end
    object qry_alunoALU_FOTO: TStringField
      FieldName = 'ALU_FOTO'
      Size = 200
    end
    object qry_alunoALU_GRAU_PARENTESCO1: TStringField
      FieldName = 'ALU_GRAU_PARENTESCO1'
      Size = 50
    end
    object qry_alunoALU_GRAU_PARENTESCO2: TStringField
      FieldName = 'ALU_GRAU_PARENTESCO2'
      Size = 50
    end
    object qry_alunoALU_ID: TIntegerField
      FieldName = 'ALU_ID'
      Required = True
    end
    object qry_alunoALU_NACIONALIDADE: TStringField
      FieldName = 'ALU_NACIONALIDADE'
      Size = 30
    end
    object qry_alunoALU_NATURALIDADE: TStringField
      FieldName = 'ALU_NATURALIDADE'
      Size = 50
    end
    object qry_alunoALU_NOME: TStringField
      FieldName = 'ALU_NOME'
      Size = 60
    end
    object qry_alunoALU_NOME_MAE: TStringField
      FieldName = 'ALU_NOME_MAE'
      Size = 100
    end
    object qry_alunoALU_NOME_PAI: TStringField
      FieldName = 'ALU_NOME_PAI'
      Size = 100
    end
    object qry_alunoALU_NOME_PLANO_SAUDE: TStringField
      FieldName = 'ALU_NOME_PLANO_SAUDE'
      Size = 50
    end
    object qry_alunoALU_NOME_RESPONSAVEL1: TStringField
      FieldName = 'ALU_NOME_RESPONSAVEL1'
      Size = 100
    end
    object qry_alunoALU_NOME_RESPONSAVEL2: TStringField
      FieldName = 'ALU_NOME_RESPONSAVEL2'
      Size = 100
    end
    object qry_alunoALU_NUMERO: TStringField
      FieldName = 'ALU_NUMERO'
      Size = 10
    end
    object qry_alunoALU_NUMERO_CARTERINHA: TStringField
      FieldName = 'ALU_NUMERO_CARTERINHA'
      Size = 30
    end
    object qry_alunoALU_NUMERO_MATRICULA: TIntegerField
      FieldName = 'ALU_NUMERO_MATRICULA'
    end
    object qry_alunoALU_NUMERO1: TStringField
      FieldName = 'ALU_NUMERO1'
      Size = 10
    end
    object qry_alunoALU_NUMERO2: TStringField
      FieldName = 'ALU_NUMERO2'
      Size = 11
    end
    object qry_alunoALU_OBSERVACOES: TMemoField
      FieldName = 'ALU_OBSERVACOES'
      BlobType = ftMemo
      Size = 1
    end
    object qry_alunoALU_ORGAO_EMISSOR: TStringField
      FieldName = 'ALU_ORGAO_EMISSOR'
      Size = 6
    end
    object qry_alunoALU_POSSUI_ALERGIA: TStringField
      FieldName = 'ALU_POSSUI_ALERGIA'
      FixedChar = True
      Size = 1
    end
    object qry_alunoALU_RG: TIntegerField
      FieldName = 'ALU_RG'
    end
    object qry_alunoALU_SEXO: TStringField
      FieldName = 'ALU_SEXO'
      FixedChar = True
      Size = 1
    end
    object qry_alunoALU_SITUACAO: TStringField
      FieldName = 'ALU_SITUACAO'
      Size = 10
    end
    object qry_alunoALU_TELEFONE: TStringField
      FieldName = 'ALU_TELEFONE'
      Size = 11
    end
    object qry_alunoALU_TELEFONE_SAUDE: TStringField
      FieldName = 'ALU_TELEFONE_SAUDE'
      Size = 11
    end
    object qry_alunoALU_TELEFONE1: TStringField
      FieldName = 'ALU_TELEFONE1'
      Size = 11
    end
    object qry_alunoALU_TELEFONE2: TStringField
      FieldName = 'ALU_TELEFONE2'
      Size = 11
    end
    object qry_alunoALU_TIPO_SANGUINEO: TStringField
      FieldName = 'ALU_TIPO_SANGUINEO'
      FixedChar = True
      Size = 2
    end
    object qry_alunoALU_VACINAS: TMemoField
      FieldName = 'ALU_VACINAS'
      BlobType = ftMemo
      Size = 1
    end
  end
  object dsp_aluno: TDataSetProvider
    DataSet = qry_aluno
    Left = 112
    Top = 136
  end
  object cds_aluno: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'dsp_aluno'
    Left = 112
    Top = 184
    object cds_alunoALU_ALERGIA: TMemoField
      FieldName = 'ALU_ALERGIA'
      BlobType = ftMemo
      Size = 1
    end
    object cds_alunoALU_BAIRRO: TStringField
      FieldName = 'ALU_BAIRRO'
      Size = 40
    end
    object cds_alunoALU_BAIRRO1: TStringField
      FieldName = 'ALU_BAIRRO1'
      Size = 40
    end
    object cds_alunoALU_BAIRRO2: TStringField
      FieldName = 'ALU_BAIRRO2'
      Size = 40
    end
    object cds_alunoALU_CIDADE: TStringField
      FieldName = 'ALU_CIDADE'
      Size = 50
    end
    object cds_alunoALU_CIDADE1: TStringField
      FieldName = 'ALU_CIDADE1'
      Size = 50
    end
    object cds_alunoALU_CIDADE2: TStringField
      FieldName = 'ALU_CIDADE2'
      Size = 50
    end
    object cds_alunoALU_DATA_DESLIGAMENTO: TDateField
      FieldName = 'ALU_DATA_DESLIGAMENTO'
    end
    object cds_alunoALU_DATA_MATRICULA: TDateField
      FieldName = 'ALU_DATA_MATRICULA'
    end
    object cds_alunoALU_DATA_NASC: TDateField
      FieldName = 'ALU_DATA_NASC'
    end
    object cds_alunoALU_DEFICIENCAS: TMemoField
      FieldName = 'ALU_DEFICIENCAS'
      BlobType = ftMemo
      Size = 1
    end
    object cds_alunoALU_DOENCA: TMemoField
      FieldName = 'ALU_DOENCA'
      BlobType = ftMemo
      Size = 1
    end
    object cds_alunoALU_DOENCA_CONTAGIOSA: TMemoField
      FieldName = 'ALU_DOENCA_CONTAGIOSA'
      BlobType = ftMemo
      Size = 1
    end
    object cds_alunoALU_ENDERECO: TStringField
      FieldName = 'ALU_ENDERECO'
      Size = 30
    end
    object cds_alunoALU_ENDERECO1: TStringField
      FieldName = 'ALU_ENDERECO1'
      Size = 30
    end
    object cds_alunoALU_ENDERECO2: TStringField
      FieldName = 'ALU_ENDERECO2'
      Size = 30
    end
    object cds_alunoALU_FKTUR_ID: TIntegerField
      FieldName = 'ALU_FKTUR_ID'
    end
    object cds_alunoALU_FOTO: TStringField
      FieldName = 'ALU_FOTO'
      Size = 200
    end
    object cds_alunoALU_GRAU_PARENTESCO1: TStringField
      FieldName = 'ALU_GRAU_PARENTESCO1'
      Size = 50
    end
    object cds_alunoALU_GRAU_PARENTESCO2: TStringField
      FieldName = 'ALU_GRAU_PARENTESCO2'
      Size = 50
    end
    object cds_alunoALU_ID: TIntegerField
      FieldName = 'ALU_ID'
      Required = True
    end
    object cds_alunoALU_NACIONALIDADE: TStringField
      FieldName = 'ALU_NACIONALIDADE'
      Size = 30
    end
    object cds_alunoALU_NATURALIDADE: TStringField
      FieldName = 'ALU_NATURALIDADE'
      Size = 50
    end
    object cds_alunoALU_NOME: TStringField
      FieldName = 'ALU_NOME'
      Size = 60
    end
    object cds_alunoALU_NOME_MAE: TStringField
      FieldName = 'ALU_NOME_MAE'
      Size = 100
    end
    object cds_alunoALU_NOME_PAI: TStringField
      FieldName = 'ALU_NOME_PAI'
      Size = 100
    end
    object cds_alunoALU_NOME_PLANO_SAUDE: TStringField
      FieldName = 'ALU_NOME_PLANO_SAUDE'
      Size = 50
    end
    object cds_alunoALU_NOME_RESPONSAVEL1: TStringField
      FieldName = 'ALU_NOME_RESPONSAVEL1'
      Size = 100
    end
    object cds_alunoALU_NOME_RESPONSAVEL2: TStringField
      FieldName = 'ALU_NOME_RESPONSAVEL2'
      Size = 100
    end
    object cds_alunoALU_NUMERO: TStringField
      FieldName = 'ALU_NUMERO'
      Size = 10
    end
    object cds_alunoALU_NUMERO_CARTERINHA: TStringField
      FieldName = 'ALU_NUMERO_CARTERINHA'
      Size = 30
    end
    object cds_alunoALU_NUMERO_MATRICULA: TIntegerField
      FieldName = 'ALU_NUMERO_MATRICULA'
    end
    object cds_alunoALU_NUMERO1: TStringField
      FieldName = 'ALU_NUMERO1'
      Size = 10
    end
    object cds_alunoALU_NUMERO2: TStringField
      FieldName = 'ALU_NUMERO2'
      Size = 11
    end
    object cds_alunoALU_OBSERVACOES: TMemoField
      FieldName = 'ALU_OBSERVACOES'
      BlobType = ftMemo
      Size = 1
    end
    object cds_alunoALU_ORGAO_EMISSOR: TStringField
      FieldName = 'ALU_ORGAO_EMISSOR'
      Size = 6
    end
    object cds_alunoALU_POSSUI_ALERGIA: TStringField
      FieldName = 'ALU_POSSUI_ALERGIA'
      FixedChar = True
      Size = 1
    end
    object cds_alunoALU_RG: TIntegerField
      FieldName = 'ALU_RG'
    end
    object cds_alunoALU_SEXO: TStringField
      FieldName = 'ALU_SEXO'
      FixedChar = True
      Size = 1
    end
    object cds_alunoALU_SITUACAO: TStringField
      FieldName = 'ALU_SITUACAO'
      Size = 10
    end
    object cds_alunoALU_TELEFONE: TStringField
      FieldName = 'ALU_TELEFONE'
      Size = 11
    end
    object cds_alunoALU_TELEFONE_SAUDE: TStringField
      FieldName = 'ALU_TELEFONE_SAUDE'
      Size = 11
    end
    object cds_alunoALU_TELEFONE1: TStringField
      FieldName = 'ALU_TELEFONE1'
      Size = 11
    end
    object cds_alunoALU_TELEFONE2: TStringField
      FieldName = 'ALU_TELEFONE2'
      Size = 11
    end
    object cds_alunoALU_TIPO_SANGUINEO: TStringField
      FieldName = 'ALU_TIPO_SANGUINEO'
      FixedChar = True
      Size = 2
    end
    object cds_alunoALU_VACINAS: TMemoField
      FieldName = 'ALU_VACINAS'
      BlobType = ftMemo
      Size = 1
    end
  end
  object ds_aluno: TDataSource
    AutoEdit = False
    DataSet = cds_aluno
    Left = 104
    Top = 240
  end
  object qry_busca_aluno: TSQLDataSet
    CommandText = 
      'select ALU_ALERGIA, ALU_BAIRRO, ALU_BAIRRO1, ALU_BAIRRO2, ALU_CI' +
      'DADE, ALU_CIDADE1, ALU_CIDADE2, ALU_DATA_DESLIGAMENTO, ALU_DATA_' +
      'MATRICULA, ALU_DATA_NASC, ALU_DEFICIENCAS, ALU_DOENCA, ALU_DOENC' +
      'A_CONTAGIOSA, ALU_ENDERECO, ALU_ENDERECO1, ALU_ENDERECO2, ALU_FK' +
      'TUR_ID, ALU_FOTO, ALU_GRAU_PARENTESCO1, ALU_GRAU_PARENTESCO2, AL' +
      'U_ID, ALU_NACIONALIDADE, ALU_NATURALIDADE, ALU_NOME, ALU_NOME_MA' +
      'E, ALU_NOME_PAI, ALU_NOME_PLANO_SAUDE, ALU_NOME_RESPONSAVEL1, AL' +
      'U_NOME_RESPONSAVEL2, ALU_NUMERO, ALU_NUMERO_CARTERINHA, ALU_NUME' +
      'RO_MATRICULA, ALU_NUMERO1, ALU_NUMERO2, ALU_OBSERVACOES, ALU_ORG' +
      'AO_EMISSOR, ALU_POSSUI_ALERGIA, ALU_RG, ALU_SEXO, ALU_SITUACAO, ' +
      'ALU_TELEFONE, ALU_TELEFONE_SAUDE, ALU_TELEFONE1, ALU_TELEFONE2, ' +
      'ALU_TIPO_SANGUINEO, ALU_VACINAS'#13#10'from aluno'
    MaxBlobSize = 1
    Params = <>
    SQLConnection = sql_con
    Left = 200
    Top = 88
    object MemoField1: TMemoField
      FieldName = 'ALU_ALERGIA'
      BlobType = ftMemo
      Size = 1
    end
    object StringField1: TStringField
      FieldName = 'ALU_BAIRRO'
      Size = 40
    end
    object StringField2: TStringField
      FieldName = 'ALU_BAIRRO1'
      Size = 40
    end
    object StringField3: TStringField
      FieldName = 'ALU_BAIRRO2'
      Size = 40
    end
    object StringField4: TStringField
      FieldName = 'ALU_CIDADE'
      Size = 50
    end
    object StringField5: TStringField
      FieldName = 'ALU_CIDADE1'
      Size = 50
    end
    object StringField6: TStringField
      FieldName = 'ALU_CIDADE2'
      Size = 50
    end
    object DateField1: TDateField
      FieldName = 'ALU_DATA_DESLIGAMENTO'
    end
    object DateField2: TDateField
      FieldName = 'ALU_DATA_MATRICULA'
    end
    object DateField3: TDateField
      FieldName = 'ALU_DATA_NASC'
    end
    object MemoField2: TMemoField
      FieldName = 'ALU_DEFICIENCAS'
      BlobType = ftMemo
      Size = 1
    end
    object MemoField3: TMemoField
      FieldName = 'ALU_DOENCA'
      BlobType = ftMemo
      Size = 1
    end
    object MemoField4: TMemoField
      FieldName = 'ALU_DOENCA_CONTAGIOSA'
      BlobType = ftMemo
      Size = 1
    end
    object StringField7: TStringField
      FieldName = 'ALU_ENDERECO'
      Size = 30
    end
    object StringField8: TStringField
      FieldName = 'ALU_ENDERECO1'
      Size = 30
    end
    object StringField9: TStringField
      FieldName = 'ALU_ENDERECO2'
      Size = 30
    end
    object IntegerField1: TIntegerField
      FieldName = 'ALU_FKTUR_ID'
    end
    object StringField10: TStringField
      FieldName = 'ALU_FOTO'
      Size = 200
    end
    object StringField11: TStringField
      FieldName = 'ALU_GRAU_PARENTESCO1'
      Size = 50
    end
    object StringField12: TStringField
      FieldName = 'ALU_GRAU_PARENTESCO2'
      Size = 50
    end
    object IntegerField2: TIntegerField
      FieldName = 'ALU_ID'
      Required = True
    end
    object StringField13: TStringField
      FieldName = 'ALU_NACIONALIDADE'
      Size = 30
    end
    object StringField14: TStringField
      FieldName = 'ALU_NATURALIDADE'
      Size = 50
    end
    object StringField15: TStringField
      FieldName = 'ALU_NOME'
      Size = 60
    end
    object StringField16: TStringField
      FieldName = 'ALU_NOME_MAE'
      Size = 100
    end
    object StringField17: TStringField
      FieldName = 'ALU_NOME_PAI'
      Size = 100
    end
    object StringField18: TStringField
      FieldName = 'ALU_NOME_PLANO_SAUDE'
      Size = 50
    end
    object StringField19: TStringField
      FieldName = 'ALU_NOME_RESPONSAVEL1'
      Size = 100
    end
    object StringField20: TStringField
      FieldName = 'ALU_NOME_RESPONSAVEL2'
      Size = 100
    end
    object StringField21: TStringField
      FieldName = 'ALU_NUMERO'
      Size = 10
    end
    object StringField22: TStringField
      FieldName = 'ALU_NUMERO_CARTERINHA'
      Size = 30
    end
    object IntegerField3: TIntegerField
      FieldName = 'ALU_NUMERO_MATRICULA'
    end
    object StringField23: TStringField
      FieldName = 'ALU_NUMERO1'
      Size = 10
    end
    object StringField24: TStringField
      FieldName = 'ALU_NUMERO2'
      Size = 11
    end
    object MemoField5: TMemoField
      FieldName = 'ALU_OBSERVACOES'
      BlobType = ftMemo
      Size = 1
    end
    object StringField25: TStringField
      FieldName = 'ALU_ORGAO_EMISSOR'
      Size = 6
    end
    object StringField26: TStringField
      FieldName = 'ALU_POSSUI_ALERGIA'
      FixedChar = True
      Size = 1
    end
    object IntegerField4: TIntegerField
      FieldName = 'ALU_RG'
    end
    object StringField27: TStringField
      FieldName = 'ALU_SEXO'
      FixedChar = True
      Size = 1
    end
    object StringField28: TStringField
      FieldName = 'ALU_SITUACAO'
      Size = 10
    end
    object StringField29: TStringField
      FieldName = 'ALU_TELEFONE'
      Size = 11
    end
    object StringField30: TStringField
      FieldName = 'ALU_TELEFONE_SAUDE'
      Size = 11
    end
    object StringField31: TStringField
      FieldName = 'ALU_TELEFONE1'
      Size = 11
    end
    object StringField32: TStringField
      FieldName = 'ALU_TELEFONE2'
      Size = 11
    end
    object StringField33: TStringField
      FieldName = 'ALU_TIPO_SANGUINEO'
      FixedChar = True
      Size = 2
    end
    object MemoField6: TMemoField
      FieldName = 'ALU_VACINAS'
      BlobType = ftMemo
      Size = 1
    end
  end
  object dsp_busca_aluno: TDataSetProvider
    DataSet = qry_busca_aluno
    Left = 200
    Top = 136
  end
  object cds_busca_aluno: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'dsp_busca_aluno'
    Left = 200
    Top = 192
    object MemoField7: TMemoField
      FieldName = 'ALU_ALERGIA'
      BlobType = ftMemo
      Size = 1
    end
    object StringField34: TStringField
      FieldName = 'ALU_BAIRRO'
      Size = 40
    end
    object StringField35: TStringField
      FieldName = 'ALU_BAIRRO1'
      Size = 40
    end
    object StringField36: TStringField
      FieldName = 'ALU_BAIRRO2'
      Size = 40
    end
    object StringField37: TStringField
      FieldName = 'ALU_CIDADE'
      Size = 50
    end
    object StringField38: TStringField
      FieldName = 'ALU_CIDADE1'
      Size = 50
    end
    object StringField39: TStringField
      FieldName = 'ALU_CIDADE2'
      Size = 50
    end
    object DateField4: TDateField
      FieldName = 'ALU_DATA_DESLIGAMENTO'
    end
    object DateField5: TDateField
      FieldName = 'ALU_DATA_MATRICULA'
    end
    object DateField6: TDateField
      FieldName = 'ALU_DATA_NASC'
    end
    object MemoField8: TMemoField
      FieldName = 'ALU_DEFICIENCAS'
      BlobType = ftMemo
      Size = 1
    end
    object MemoField9: TMemoField
      FieldName = 'ALU_DOENCA'
      BlobType = ftMemo
      Size = 1
    end
    object MemoField10: TMemoField
      FieldName = 'ALU_DOENCA_CONTAGIOSA'
      BlobType = ftMemo
      Size = 1
    end
    object StringField40: TStringField
      FieldName = 'ALU_ENDERECO'
      Size = 30
    end
    object StringField41: TStringField
      FieldName = 'ALU_ENDERECO1'
      Size = 30
    end
    object StringField42: TStringField
      FieldName = 'ALU_ENDERECO2'
      Size = 30
    end
    object IntegerField5: TIntegerField
      FieldName = 'ALU_FKTUR_ID'
    end
    object StringField43: TStringField
      FieldName = 'ALU_FOTO'
      Size = 200
    end
    object StringField44: TStringField
      FieldName = 'ALU_GRAU_PARENTESCO1'
      Size = 50
    end
    object StringField45: TStringField
      FieldName = 'ALU_GRAU_PARENTESCO2'
      Size = 50
    end
    object IntegerField6: TIntegerField
      FieldName = 'ALU_ID'
      Required = True
    end
    object StringField46: TStringField
      FieldName = 'ALU_NACIONALIDADE'
      Size = 30
    end
    object StringField47: TStringField
      FieldName = 'ALU_NATURALIDADE'
      Size = 50
    end
    object StringField48: TStringField
      FieldName = 'ALU_NOME'
      Size = 60
    end
    object StringField49: TStringField
      FieldName = 'ALU_NOME_MAE'
      Size = 100
    end
    object StringField50: TStringField
      FieldName = 'ALU_NOME_PAI'
      Size = 100
    end
    object StringField51: TStringField
      FieldName = 'ALU_NOME_PLANO_SAUDE'
      Size = 50
    end
    object StringField52: TStringField
      FieldName = 'ALU_NOME_RESPONSAVEL1'
      Size = 100
    end
    object StringField53: TStringField
      FieldName = 'ALU_NOME_RESPONSAVEL2'
      Size = 100
    end
    object StringField54: TStringField
      FieldName = 'ALU_NUMERO'
      Size = 10
    end
    object StringField55: TStringField
      FieldName = 'ALU_NUMERO_CARTERINHA'
      Size = 30
    end
    object IntegerField7: TIntegerField
      FieldName = 'ALU_NUMERO_MATRICULA'
    end
    object StringField56: TStringField
      FieldName = 'ALU_NUMERO1'
      Size = 10
    end
    object StringField57: TStringField
      FieldName = 'ALU_NUMERO2'
      Size = 11
    end
    object MemoField11: TMemoField
      FieldName = 'ALU_OBSERVACOES'
      BlobType = ftMemo
      Size = 1
    end
    object StringField58: TStringField
      FieldName = 'ALU_ORGAO_EMISSOR'
      Size = 6
    end
    object StringField59: TStringField
      FieldName = 'ALU_POSSUI_ALERGIA'
      FixedChar = True
      Size = 1
    end
    object IntegerField8: TIntegerField
      FieldName = 'ALU_RG'
    end
    object StringField60: TStringField
      FieldName = 'ALU_SEXO'
      FixedChar = True
      Size = 1
    end
    object StringField61: TStringField
      FieldName = 'ALU_SITUACAO'
      Size = 10
    end
    object StringField62: TStringField
      FieldName = 'ALU_TELEFONE'
      Size = 11
    end
    object StringField63: TStringField
      FieldName = 'ALU_TELEFONE_SAUDE'
      Size = 11
    end
    object StringField64: TStringField
      FieldName = 'ALU_TELEFONE1'
      Size = 11
    end
    object StringField65: TStringField
      FieldName = 'ALU_TELEFONE2'
      Size = 11
    end
    object StringField66: TStringField
      FieldName = 'ALU_TIPO_SANGUINEO'
      FixedChar = True
      Size = 2
    end
    object MemoField12: TMemoField
      FieldName = 'ALU_VACINAS'
      BlobType = ftMemo
      Size = 1
    end
  end
  object ds_busca_aluno: TDataSource
    DataSet = cds_busca_aluno
    Left = 200
    Top = 248
  end
  object qry_turma: TSQLDataSet
    CommandText = 
      'select TUR_ANO, '#13#10'TUR_FKALU_ID, '#13#10'TUR_ID, '#13#10'TUR_PERIODO, '#13#10'ALU_N' +
      'OME TUR_NOMEALUNO,'#13#10'TUR_TURMA '#13#10'FROM TURMAS'#13#10'Inner join aluno  o' +
      'n ( tur_fkalu_id  = Alu_id)'
    MaxBlobSize = 1
    Params = <>
    SQLConnection = sql_con
    Left = 472
    Top = 88
    object qry_turmaTUR_ANO: TStringField
      FieldName = 'TUR_ANO'
      Size = 4
    end
    object qry_turmaTUR_FKALU_ID: TIntegerField
      FieldName = 'TUR_FKALU_ID'
    end
    object qry_turmaTUR_ID: TIntegerField
      FieldName = 'TUR_ID'
      Required = True
    end
    object qry_turmaTUR_PERIODO: TStringField
      FieldName = 'TUR_PERIODO'
      Size = 30
    end
    object qry_turmaTUR_TURMA: TStringField
      FieldName = 'TUR_TURMA'
      Size = 30
    end
    object qry_turmaTUR_NOMEALUNO: TStringField
      FieldName = 'TUR_NOMEALUNO'
      ProviderFlags = []
      Size = 60
    end
  end
  object dsp_turma: TDataSetProvider
    DataSet = qry_turma
    Left = 472
    Top = 136
  end
  object cds_turma: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'dsp_turma'
    Left = 472
    Top = 184
    object cds_turmaTUR_ANO: TStringField
      FieldName = 'TUR_ANO'
      Size = 4
    end
    object cds_turmaTUR_FKALU_ID: TIntegerField
      FieldName = 'TUR_FKALU_ID'
    end
    object cds_turmaTUR_ID: TIntegerField
      FieldName = 'TUR_ID'
      Required = True
    end
    object cds_turmaTUR_PERIODO: TStringField
      FieldName = 'TUR_PERIODO'
      Size = 30
    end
    object cds_turmaTUR_TURMA: TStringField
      FieldName = 'TUR_TURMA'
      Size = 30
    end
    object cds_turmaTUR_NOMEALUNO: TStringField
      FieldName = 'TUR_NOMEALUNO'
      ProviderFlags = []
      Size = 60
    end
  end
  object ds_turma: TDataSource
    DataSet = cds_turma
    Left = 464
    Top = 240
  end
  object qry_turmaSQLDataSet: TSQLDataSet
    CommandText = 
      'select ALU_ALERGIA, ALU_BAIRRO, ALU_BAIRRO1, ALU_BAIRRO2, ALU_CI' +
      'DADE, ALU_CIDADE1, ALU_CIDADE2, ALU_DATA_DESLIGAMENTO, ALU_DATA_' +
      'MATRICULA, ALU_DATA_NASC, ALU_DEFICIENCAS, ALU_DOENCA, ALU_DOENC' +
      'A_CONTAGIOSA, ALU_ENDERECO, ALU_ENDERECO1, ALU_ENDERECO2, ALU_FK' +
      'TUR_ID, ALU_FOTO, ALU_GRAU_PARENTESCO1, ALU_GRAU_PARENTESCO2, AL' +
      'U_ID, ALU_NACIONALIDADE, ALU_NATURALIDADE, ALU_NOME, ALU_NOME_MA' +
      'E, ALU_NOME_PAI, ALU_NOME_PLANO_SAUDE, ALU_NOME_RESPONSAVEL1, AL' +
      'U_NOME_RESPONSAVEL2, ALU_NUMERO, ALU_NUMERO_CARTERINHA, ALU_NUME' +
      'RO_MATRICULA, ALU_NUMERO1, ALU_NUMERO2, ALU_OBSERVACOES, ALU_ORG' +
      'AO_EMISSOR, ALU_POSSUI_ALERGIA, ALU_RG, ALU_SEXO, ALU_SITUACAO, ' +
      'ALU_TELEFONE, ALU_TELEFONE_SAUDE, ALU_TELEFONE1, ALU_TELEFONE2, ' +
      'ALU_TIPO_SANGUINEO, ALU_VACINAS'#13#10'from aluno'
    MaxBlobSize = 1
    Params = <>
    SQLConnection = sql_con
    Left = 296
    Top = 96
    object qry_turmaMemoField: TMemoField
      FieldName = 'ALU_ALERGIA'
      BlobType = ftMemo
      Size = 1
    end
    object qry_turmaStringField: TStringField
      FieldName = 'ALU_BAIRRO'
      Size = 40
    end
    object qry_turmaStringField2: TStringField
      FieldName = 'ALU_BAIRRO1'
      Size = 40
    end
    object qry_turmaStringField3: TStringField
      FieldName = 'ALU_BAIRRO2'
      Size = 40
    end
    object qry_turmaStringField4: TStringField
      FieldName = 'ALU_CIDADE'
      Size = 50
    end
    object qry_turmaStringField5: TStringField
      FieldName = 'ALU_CIDADE1'
      Size = 50
    end
    object qry_turmaStringField6: TStringField
      FieldName = 'ALU_CIDADE2'
      Size = 50
    end
    object qry_turmaDateField: TDateField
      FieldName = 'ALU_DATA_DESLIGAMENTO'
    end
    object qry_turmaDateField2: TDateField
      FieldName = 'ALU_DATA_MATRICULA'
    end
    object qry_turmaDateField3: TDateField
      FieldName = 'ALU_DATA_NASC'
    end
    object qry_turmaMemoField2: TMemoField
      FieldName = 'ALU_DEFICIENCAS'
      BlobType = ftMemo
      Size = 1
    end
    object qry_turmaMemoField3: TMemoField
      FieldName = 'ALU_DOENCA'
      BlobType = ftMemo
      Size = 1
    end
    object qry_turmaMemoField4: TMemoField
      FieldName = 'ALU_DOENCA_CONTAGIOSA'
      BlobType = ftMemo
      Size = 1
    end
    object qry_turmaStringField7: TStringField
      FieldName = 'ALU_ENDERECO'
      Size = 30
    end
    object qry_turmaStringField8: TStringField
      FieldName = 'ALU_ENDERECO1'
      Size = 30
    end
    object qry_turmaStringField9: TStringField
      FieldName = 'ALU_ENDERECO2'
      Size = 30
    end
    object qry_turmaIntegerField: TIntegerField
      FieldName = 'ALU_FKTUR_ID'
    end
    object qry_turmaStringField10: TStringField
      FieldName = 'ALU_FOTO'
      Size = 200
    end
    object qry_turmaStringField11: TStringField
      FieldName = 'ALU_GRAU_PARENTESCO1'
      Size = 50
    end
    object qry_turmaStringField12: TStringField
      FieldName = 'ALU_GRAU_PARENTESCO2'
      Size = 50
    end
    object qry_turmaIntegerField2: TIntegerField
      FieldName = 'ALU_ID'
      Required = True
    end
    object qry_turmaStringField13: TStringField
      FieldName = 'ALU_NACIONALIDADE'
      Size = 30
    end
    object qry_turmaStringField14: TStringField
      FieldName = 'ALU_NATURALIDADE'
      Size = 50
    end
    object qry_turmaStringField15: TStringField
      FieldName = 'ALU_NOME'
      Size = 60
    end
    object qry_turmaStringField16: TStringField
      FieldName = 'ALU_NOME_MAE'
      Size = 100
    end
    object qry_turmaStringField17: TStringField
      FieldName = 'ALU_NOME_PAI'
      Size = 100
    end
    object qry_turmaStringField18: TStringField
      FieldName = 'ALU_NOME_PLANO_SAUDE'
      Size = 50
    end
    object qry_turmaStringField19: TStringField
      FieldName = 'ALU_NOME_RESPONSAVEL1'
      Size = 100
    end
    object qry_turmaStringField20: TStringField
      FieldName = 'ALU_NOME_RESPONSAVEL2'
      Size = 100
    end
    object qry_turmaStringField21: TStringField
      FieldName = 'ALU_NUMERO'
      Size = 10
    end
    object qry_turmaStringField22: TStringField
      FieldName = 'ALU_NUMERO_CARTERINHA'
      Size = 30
    end
    object qry_turmaIntegerField3: TIntegerField
      FieldName = 'ALU_NUMERO_MATRICULA'
    end
    object qry_turmaStringField23: TStringField
      FieldName = 'ALU_NUMERO1'
      Size = 10
    end
    object qry_turmaStringField24: TStringField
      FieldName = 'ALU_NUMERO2'
      Size = 11
    end
    object qry_turmaMemoField5: TMemoField
      FieldName = 'ALU_OBSERVACOES'
      BlobType = ftMemo
      Size = 1
    end
    object qry_turmaStringField25: TStringField
      FieldName = 'ALU_ORGAO_EMISSOR'
      Size = 6
    end
    object qry_turmaStringField26: TStringField
      FieldName = 'ALU_POSSUI_ALERGIA'
      FixedChar = True
      Size = 1
    end
    object qry_turmaIntegerField4: TIntegerField
      FieldName = 'ALU_RG'
    end
    object qry_turmaStringField27: TStringField
      FieldName = 'ALU_SEXO'
      FixedChar = True
      Size = 1
    end
    object qry_turmaStringField28: TStringField
      FieldName = 'ALU_SITUACAO'
      Size = 10
    end
    object qry_turmaStringField29: TStringField
      FieldName = 'ALU_TELEFONE'
      Size = 11
    end
    object qry_turmaStringField30: TStringField
      FieldName = 'ALU_TELEFONE_SAUDE'
      Size = 11
    end
    object qry_turmaStringField31: TStringField
      FieldName = 'ALU_TELEFONE1'
      Size = 11
    end
    object qry_turmaStringField32: TStringField
      FieldName = 'ALU_TELEFONE2'
      Size = 11
    end
    object qry_turmaStringField33: TStringField
      FieldName = 'ALU_TIPO_SANGUINEO'
      FixedChar = True
      Size = 2
    end
    object qry_turmaMemoField6: TMemoField
      FieldName = 'ALU_VACINAS'
      BlobType = ftMemo
      Size = 1
    end
  end
  object qry_turmaDataSetProvider: TDataSetProvider
    DataSet = qry_busca_aluno
    Left = 296
    Top = 160
  end
  object qry_turmaClientDataSet: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'dsp_busca_aluno'
    Left = 304
    Top = 216
    object qry_turmaMemoField7: TMemoField
      FieldName = 'ALU_ALERGIA'
      BlobType = ftMemo
      Size = 1
    end
    object qry_turmaStringField34: TStringField
      FieldName = 'ALU_BAIRRO'
      Size = 40
    end
    object qry_turmaStringField35: TStringField
      FieldName = 'ALU_BAIRRO1'
      Size = 40
    end
    object qry_turmaStringField36: TStringField
      FieldName = 'ALU_BAIRRO2'
      Size = 40
    end
    object qry_turmaStringField37: TStringField
      FieldName = 'ALU_CIDADE'
      Size = 50
    end
    object qry_turmaStringField38: TStringField
      FieldName = 'ALU_CIDADE1'
      Size = 50
    end
    object qry_turmaStringField39: TStringField
      FieldName = 'ALU_CIDADE2'
      Size = 50
    end
    object qry_turmaDateField4: TDateField
      FieldName = 'ALU_DATA_DESLIGAMENTO'
    end
    object qry_turmaDateField5: TDateField
      FieldName = 'ALU_DATA_MATRICULA'
    end
    object qry_turmaDateField6: TDateField
      FieldName = 'ALU_DATA_NASC'
    end
    object qry_turmaMemoField8: TMemoField
      FieldName = 'ALU_DEFICIENCAS'
      BlobType = ftMemo
      Size = 1
    end
    object qry_turmaMemoField9: TMemoField
      FieldName = 'ALU_DOENCA'
      BlobType = ftMemo
      Size = 1
    end
    object qry_turmaMemoField10: TMemoField
      FieldName = 'ALU_DOENCA_CONTAGIOSA'
      BlobType = ftMemo
      Size = 1
    end
    object qry_turmaStringField40: TStringField
      FieldName = 'ALU_ENDERECO'
      Size = 30
    end
    object qry_turmaStringField41: TStringField
      FieldName = 'ALU_ENDERECO1'
      Size = 30
    end
    object qry_turmaStringField42: TStringField
      FieldName = 'ALU_ENDERECO2'
      Size = 30
    end
    object qry_turmaIntegerField5: TIntegerField
      FieldName = 'ALU_FKTUR_ID'
    end
    object qry_turmaStringField43: TStringField
      FieldName = 'ALU_FOTO'
      Size = 200
    end
    object qry_turmaStringField44: TStringField
      FieldName = 'ALU_GRAU_PARENTESCO1'
      Size = 50
    end
    object qry_turmaStringField45: TStringField
      FieldName = 'ALU_GRAU_PARENTESCO2'
      Size = 50
    end
    object qry_turmaIntegerField6: TIntegerField
      FieldName = 'ALU_ID'
      Required = True
    end
    object qry_turmaStringField46: TStringField
      FieldName = 'ALU_NACIONALIDADE'
      Size = 30
    end
    object qry_turmaStringField47: TStringField
      FieldName = 'ALU_NATURALIDADE'
      Size = 50
    end
    object qry_turmaStringField48: TStringField
      FieldName = 'ALU_NOME'
      Size = 60
    end
    object qry_turmaStringField49: TStringField
      FieldName = 'ALU_NOME_MAE'
      Size = 100
    end
    object qry_turmaStringField50: TStringField
      FieldName = 'ALU_NOME_PAI'
      Size = 100
    end
    object qry_turmaStringField51: TStringField
      FieldName = 'ALU_NOME_PLANO_SAUDE'
      Size = 50
    end
    object qry_turmaStringField52: TStringField
      FieldName = 'ALU_NOME_RESPONSAVEL1'
      Size = 100
    end
    object qry_turmaStringField53: TStringField
      FieldName = 'ALU_NOME_RESPONSAVEL2'
      Size = 100
    end
    object qry_turmaStringField54: TStringField
      FieldName = 'ALU_NUMERO'
      Size = 10
    end
    object qry_turmaStringField55: TStringField
      FieldName = 'ALU_NUMERO_CARTERINHA'
      Size = 30
    end
    object qry_turmaIntegerField7: TIntegerField
      FieldName = 'ALU_NUMERO_MATRICULA'
    end
    object qry_turmaStringField56: TStringField
      FieldName = 'ALU_NUMERO1'
      Size = 10
    end
    object qry_turmaStringField57: TStringField
      FieldName = 'ALU_NUMERO2'
      Size = 11
    end
    object qry_turmaMemoField11: TMemoField
      FieldName = 'ALU_OBSERVACOES'
      BlobType = ftMemo
      Size = 1
    end
    object qry_turmaStringField58: TStringField
      FieldName = 'ALU_ORGAO_EMISSOR'
      Size = 6
    end
    object qry_turmaStringField59: TStringField
      FieldName = 'ALU_POSSUI_ALERGIA'
      FixedChar = True
      Size = 1
    end
    object qry_turmaIntegerField8: TIntegerField
      FieldName = 'ALU_RG'
    end
    object qry_turmaStringField60: TStringField
      FieldName = 'ALU_SEXO'
      FixedChar = True
      Size = 1
    end
    object qry_turmaStringField61: TStringField
      FieldName = 'ALU_SITUACAO'
      Size = 10
    end
    object qry_turmaStringField62: TStringField
      FieldName = 'ALU_TELEFONE'
      Size = 11
    end
    object qry_turmaStringField63: TStringField
      FieldName = 'ALU_TELEFONE_SAUDE'
      Size = 11
    end
    object qry_turmaStringField64: TStringField
      FieldName = 'ALU_TELEFONE1'
      Size = 11
    end
    object qry_turmaStringField65: TStringField
      FieldName = 'ALU_TELEFONE2'
      Size = 11
    end
    object qry_turmaStringField66: TStringField
      FieldName = 'ALU_TIPO_SANGUINEO'
      FixedChar = True
      Size = 2
    end
    object qry_turmaMemoField12: TMemoField
      FieldName = 'ALU_VACINAS'
      BlobType = ftMemo
      Size = 1
    end
  end
  object ds_turmaDataSource: TDataSource
    DataSet = cds_busca_aluno
    Left = 312
    Top = 272
  end
end
